Download Excel 2013.77-420.TestKing.2018-06-19.14q.vcex

Vendor: Microsoft
Exam Code: 77-420
Exam Name: Excel 2013
Date: Jun 19, 2018
File Size: 3 MB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

ProfExam Discount

Demo Questions

Question 1
Insert a picture. 
To the right of the data 
File source Books.jpg
  1. See the explanation
Correct answer: A
Explanation:
Step 1: Click in a cell to the right of the data.Step 2: Click the INSERT tab, and then the Pictures command.  Step 3: From the Insert Picture dialog box select the Books.jpg file.
Step 1: Click in a cell to the right of the data.
Step 2: Click the INSERT tab, and then the Pictures command.
  
Step 3: From the Insert Picture dialog box select the Books.jpg file.
Question 2
Crop the picture. 
Books.jpg 
Crop to Shape Snip Same Side Corner Rectangle.
  1. See the explanation
Correct answer: A
Explanation:
Step 1: Click on the picture.Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.  
Step 1: Click on the picture.
Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.
  
Question 3
Insert the instructor's name for column B. 
Cell B5. 
Use Function RIGHT 
Text: B2
Absolute reference 
Num_chars: "16"
  1. See the explanation
Correct answer: A
Explanation:
Step 1: Open the correct worksheet (Summary Worksheet).Step 2: Click in cell B5.Step 3: Click on the insert function button.  Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.  Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.  
Step 1: Open the correct worksheet (Summary Worksheet).
Step 2: Click in cell B5.
Step 3: Click on the insert function button.
  
Step 4: In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.
  
Step 5: In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.
  
Question 4
Formula. Find the average of each student's homework scores. 
Cell range C7:C29
Use Function AVERAGE 
Number 1: all homework for each student on "Section 3" worksheet "22-Aug  12-Dec"
  1. See the explanation
Correct answer: A
Explanation:
Step 1: Click cell C7, and the click the Insert Function Button.  Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.  The function Arguments Dialog box appears:  Step 3: Click on the Section 3 tab (left bottom part of the window).  Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.  Step 5: Copy cell C7 downwards until cell C29.  Result will be like:  
Step 1: Click cell C7, and the click the Insert Function Button.
  
Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.
  
The function Arguments Dialog box appears:
  
Step 3: Click on the Section 3 tab (left bottom part of the window).
  
Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.
  
Step 5: Copy cell C7 downwards until cell C29.
  
Result will be like:
  
Question 5
Create a new named range. 
Cell range C7:C29.
Name: "Homework"
  1. See the explanation
Correct answer: A
Explanation:
Step 1: Click cell C7, and then Shift-click cell C29Step 2: Click the Name box at the left end of the formula bar. Step 3: Type: Homework. Press ENTER.  
Step 1: Click cell C7, and then Shift-click cell C29
Step 2: Click the Name box at the left end of the formula bar. 
Step 3: Type: Homework. Press ENTER.
  
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!